#!/bin/sh
cptDataDir=/opt/wf/action/dbrecord/JZCpt
dataTable='t_jingzhun_cpt_city_cate_stat'
for f in $(ls $cptDataDir/JZCptCityCateStat_2014-10*)
do
	loaddata="load data local infile '$f' into table $dataTable CHARACTER SET utf8 fields terminated by '^&' LINES TERMINATED BY '\n';"
	echo $loaddata
	echo $loaddata | mysql --auto-rehash -h10.5.20.16 -P58885 -uroot -pgroup_buytj1140 -D dbwww58com_precision_ads
done